EMT Practice Test

1. Question Content...

---

Question1: Which timeseries statement will fix the query?

Question2: Universal Containers wants to create two dashboards and has two user groups. The 'Regional Performance' dashboard should be accessible to sales reps and managers/executives to keep track of how sales reps are performing in each region. Sales reps must only be able to see data pertaining to their respective region. The 'National Performance' dashboard is using the same data as the other dashboard but should only be accessible to managers/executives to compare data across all regions.
In addition to row-level security to view only regional data, how should a consultant ensure that sales reps are unable to view the 'National Performance' dashboard?

Question3: A CRM Analytics consultant has prepared a CSV file to be uploaded to CRM Analytics. By mistake, one of the column headers is modified as random non-alphanumeric characters "*&**(&*(%", which went unnoticed prior to uploading the file.
What is the expected behavior of the uploaded CSV column?

Question4: A team of CRM Analytics developers has been working on an existing recipe to add new derived fields. The edited version has been failing ever since, and management is requesting that the dashboard show refreshed data while they work on the edits.
How can the developers add new fields while keeping the dataset refreshed?

Question5: Universal Containers' CRM Analytics team is building a dashboard with two widgets.
1. List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Donut chart widget associated to the query "Step_pie_3" and grouped by the dimension "Type" The team wants to use bindings/interactions so any selection in the List widget will filter the Donut chart. The queries use different datasets, and users should be able to choose more than one Type (multi-selection).
What is the right syntax for the binding/interaction?

Question6: The CRM Analytics consultant at Universal Containers has set data syncs and recipe runs back to back. However, they notice that the data syncs and recipe run jobs fail repeatedly. Upon investigation, they realize the data syncs and recipes are tightly coupled which leads to too many runs being queued and eventually being canceled.
How should the consultant resolve this issue?

Question7: A CRM Analytics consultant has been asked to add a custom object to existing recipe. When trying to locate the object, the consultant can see only Direct Data and NOT the SFDC Local data sync.
How should the consultant resolve this?

Question8: A CRM Analytics consultant has enabled data sync manually in an org that uses dataflows/recipes. The client says that the dataflow/recipe fails each time it starts running.
What is causing the dataflow/recipe to fail?

Question9: Universal Containers (UC) has a "Sales Manager" dashboard. UC has a compare table that has multiple groupings and columns added showing the Total and Subtotals of the numeric values. A consultant is asked to add additional groups to enhance details about UC's customers.
Which feature should the consultant use to make the navigation of the compare tables easier for the end user?

Question10: In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
How should the consultant accomplish this?

Question11: Which recommended technique should a CRM Analytics consultant
use to access CRM Analytics data from a remote app or website?

Question12: In Data Alerts, a field named Region is 96.5% North Americ
a. The consultant believes that this is an important field since the majority of sales is in the North American market.
What is the appropriate action?

Question13: Universal Containers asks a CRM Analytics consultant to review the performance of its local data sync.
After removing unused objects and fields from connected data, what else should the consultant do to improve performance of the data sync?

Question14: A consultant is tasked with creating a dataset and a dashboard for a sales team. During the requirements gathering, it was highlighted that security of the data is important.
It was noted that the Opportunity object has organization-wide defaults set to Private with access via the role hierarchy. Sales wants to keep this security in place for the dashboard. Looking at the Opportunity data, the consultant sees that the VP of sales can have access to up to 20,000 records and is unsure if sharing inheritance can be used.
Which approach ensures data security for the new Opportunity dataset?

Question15: A consultant has been asked to build and embed a dashboard in a Lightning page. Users should only be able to change the dashboard contrast and open Analytics Studio from the header of the dashboard.
How should the consultant achieve this?

Question16: A data architect wants to use a recipe transformation to implement row level security based on role hierarchy in Salesforce.
Which transformation should the architect use to level the dataset hierarchy?

Question17: The CRM Analytics consultant at AW Computing is designing dashboard. They want to add a rate between two metrics and display it in a new chart. They are finding that the new chart seems to prejudice the design of other charts.
What should the consultant do to resolve this?

Question18: A CRM Analytics consultant has been tasked with providing access to CRM Analytics for a few users. They should be able to view the data but unable to export it.
Which permission should the consultant make sure to NOT include?

Question19: The CRM Analytics consultant at Cloud Kicks (CK) notices that a specific dashboard is showing a different date and time from their locale. Upon investigating, they find that the recipe and datasets were created from a locale with a PST time zone while CK is in the CET time zone.
What led to this problem?

Question20: CRM Analytics users at Cloud Kicks are granted access to an app with specific dashboards. When trying to download a specific widget, they are unable to do so.
What is causing the issue?

Question21: A CRM Analytics administrator is working on deploying a dataflow and a dataset (generated by this dataflow) to another org.
While creating a change set, they notice that the components are NOT visible to be included in the change set.
What is the reason for this?

Question22: Universal Containers (UC) builds three Einstein Discovery models in Salesforce to predict and maximize its revenue per customer. The models are for every region UC has a business: EMEA, AMER, and APAC.
How should a consultant help UC deploy the three Einstein models to Salesforce?

Question23: A CRM Analytics consultant is performing column profiling on dimension column in a recipe. Newly-added rows are not being considered in the Results tab of the profile even though a sync was run for that specific object.
What is causing the issue?

Question24: A CRM Analytics consultant wants to move a dataflow to a recipe in order to use aggregation nodes. To do so, they use the Dataflow to Recipe convertor and the recipe runs successfully.
However, they are unable to see the aggregated data in the dataset.
What is causing the issue?

Question25: consultant is reviewing a model that is set to maximize the daily sales quantity of consumer products in stores, and they see this recommendation.

Which action should the consultant take?

Question26: Universal Containers is setting up a Sales Analytics app to track the sales performance across all regions. The role hierarchy is well-structured with separate branches for various global regions.
Viewer access has been provided to the regional sales reps based on the following roles.
* Regional Sales - APAC
* Regional Sales - EMEA
* Regional Sales - LATAM
* Regional Sales - NA
The CRM Analytics project team receives a request to extend Editor
access to the app to 20 'Superusers' across all regions.
What is the optimal solution?

Question27: What are various ways to incorporate blank space in a CRM Analytics dashboard?

Question28: Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

How should a CRM Analytics consultant help UC build this lens?

Question29: Cloud Kicks needs a CRM Analytics consultant to install the Appointment Analytics App. After installation, they realize the wrong field was picked and the app did not have access to a newly created field that should be used instead of the old one.
What is the first step the consultant should take to prevent erroneous dataset/dashboard creation?

Question30: Cloud Kicks has informed CRM Analytics developers that they have two scenarios with restricted row-level security.
The parameters being:
1. Non-CXOs and VPs working in EMEA can have access to EMEA records only.
2. CXOs and VPs should have access to all data irrespective of the region (APAC, EMEA, etc.).
Which sharing method works for this scenario?

Question31: A new picklist value was added for the Category field on the Account object. This field is already added as part of the Account object data sync and the respective recipe that uses this field.
The CRM Analytics team reports that when they start the recipe it runs successfully with no errors or warnings, but they are unable to See this new values on their existing dashboards.
What is the oridi4 of this issue?

Question32: Universal Containers has a dashboard for sales managers. They need to visualize the percentage of their opportunities in the pipeline in a Gauge chart. They want to customize the chart to keep track if they are below or beyond the target.

Which widget parameters should a consultant use?

Question33: A system administrator at Cloud Kicks creates a joined report to showcase the new business deals closing in the current quarter, which was well received by the business stakeholders. A manager wants to visualize this report on CRM Analytics.
The CRM Analytics consultant determines the report can be trended on CRM Analytics, but it's not working as expected.
What is causing the issue?

Question34: An CRM Analytics consultant creates a model to maximize the satisfaction of cases. They want to deploy the mode! and further use the model and predictions in an existing automated business process powered by Salesforce Flow.
What is the most efficient way to accomplish this?

Question35: Cloud Kicks (CK) has a dashboard in CRM Analytics with forecasting dat
a. One widget is a compare table using the timeseries function showing the quarterly forecast. However, CK is interested in enhancing the dashboard with a weekly forecast per customer.
How should CK achieve this?

Question36: The CRM Analytics consultant at Universal Containers (UC) has set up data sync for the Salesforce Opportunity object with the Amount currency field added. This is being used in multiple datasets and dashboards, as UC is a multi-currency organization.
The currency used in Salesforce records is set up in GBP but the data on the dashboard is converting to USD. Conversion logic is not set up on any of the recipes.
Why is the currency converting?

Question37: Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps' objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company's org.
Which CRM Analytics user interface features should be used to complete these requirements?

Question38: The marketing team at Cloud Kicks has five dashboards in an app. Four widgets are replicas of each other in three of the dashboards.
What is the best way to maintain these widgets?

Question39: Universal Containers (UC) recently activated data sync in the CRM Analytics data manager. After running the sync, UC notices that the aggregate sum of a field within the company's dataset is different than what they manually calculated by summing the same data in the Salesforce object.
What is causing the issue with the newly synced data?

Question40: Universal Containers has a dashboard for sales managers. They need the ability to visualize the number of Closed Won opportunities by month, quarter, or year, and then display the result in a single chart. A CRM Analytics consultant creates a custom query to display three values:
ClosedDate_month, ClosedDate_ quarter, and ClosedDate_year.
What should the consultant do next?

Question41: CRM Analytics uses permissions of the Integration User to extract data from Salesforce objects and fields when a dataflow/recipe job runs.
Why should a consultant be cautious while syncing objects and fields containing sensitive data?

Question42: Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?

Question43: Cloud Kicks has a dashboard that displays accounts and opportunities data in a table that contains actions to open the records in Salesforce. Since the company has allowed several accounts to be created with the same names, when users try to perform actions, they are prompted with only a record ID to select, leaving the users confused and unable to act.
How should the CRM Analytics consultant solve this problem?

Question44: Which statement best describes how to ensure CRM Analytics dashboards are easily used across both desktop and mobile devices?

Question45: Several users are complaining they are unable to see a specific dashboard on a Salesforce Lightning page anymore. The CRM Analytics consultant logs in as one of the users and sees an error page once the dashboard is opened.
How should the consultant solve this issue?

Question46: A user is able to access the dashboards, lenses, and datasets of a particular app but is unable to change the name of the specific app.
What is causing the issue?

Question47: A consultant is preparing a dataset to predict customer lifetime value and is collecting data from a questionnaire that asks for demographic information. A very small number of respondents fill in the Income box, but the consultant thinks that it is an informative column even though it only represents 1% of respondents.
What should the consultant do?

Question48: Universal Containers' sales team is looking to build a dashboard that shows the total revenue from their top 10 accounts (based on revenue) and make it dynamic with the filters of the dashboard.
Which action is required to accomplish this?